home *** CD-ROM | disk | FTP | other *** search
- Spreadsheet Function @IF()
- Synopsis:
-
- @IF(expression,true action,false action)
-
- Description:
-
- This function examines the expression. If the
- expression is true (in a boolean sense), then the
- true action is evaluated, else the false action is
- evaluated.
-
- Notes:
-
- @IF must be in a cell on its own. You can not have
- 10+@IF(5<6,1,0) or simular. However you can use
- other functions inside @IF as normal.
-
- Examples:
-
- @IF(A1<5,"Reorder",A1)
-
- If the contents of A1 were less than 5 then this
- would display in the cell, "Reorder", else the
- contents of A1 would appear.
- *
- Using Functions
- usefunc.help
- Maths Operators
- operators.help